I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel options. The data was imported in about two hours and the indexes took another 7 hours. There was no downtime but we kept the users off the system while this was happening.
Here is the command I used on the new server:
|
1 |
nohup impdp system/secret NETWORK_LINK=olddb FULL=y PARALLEL=25 & |
Then you can run this to see which parallel process is importing which table:
|
1 2 3 |
impdp system attach Import> status Import> parallel=30 << this will increase the parallel processes if you want |
I had created all the datafiles in the new database and created a db link named olddb beforehand. The servers were on the same local area network and the network was the bottleneck.
You can also read this on my blog.
This document contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
Load comments